UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '82uXyu6Ra8te5UmsZb7dlUps1no+MbJln7YCGWhbMfI='
WHERE
key_id = 'a164a766e3e3c79247928596da3a6274598d74f6cb0fb2593d36f406e99fc591'
AND (
token = '82uXyu6Ra8te5UmsZb7dlUps1no+MbJln7YCGWhbMfI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)