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