UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hZ5rXINA6V0+j75PPmwyCwCrLry/Bp5Joj53HPk1VkY='
WHERE
key_id = '127227e16ee4061361ca09da0f83877337d94d61fea940cefdd8afb75dbe93c5'
AND (
token = 'hZ5rXINA6V0+j75PPmwyCwCrLry/Bp5Joj53HPk1VkY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)