UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47QxnTnj8p4DJbyTYknu0vh7W8cVTyMj+5dTvGUzCn0='
WHERE
key_id = 'b26cb9d95354ec8b3a1674dd3911a00885580b4ec594a499e8524a1f7204db81'
AND (
token = '47QxnTnj8p4DJbyTYknu0vh7W8cVTyMj+5dTvGUzCn0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)