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