UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/9YbldZlOPIBBgZ1tmYrwnyCjJ4U1EjwNWrxwzi4PfU='
WHERE
key_id = '3e99c1816c3c8f2e00206a8ecb757b4612b9614b66fb0187aca3c96ef2da3c0c'
AND (
token = '/9YbldZlOPIBBgZ1tmYrwnyCjJ4U1EjwNWrxwzi4PfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)