UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ewl9nw4M1vbA7FAnz7Em50fggjkdYQDyCqkcRSJH8Z4='
WHERE
key_id = '27a09f58899ef6dd54743aba4423ec382bd5c3d67d5c81448616d4278811c011'
AND (
token = 'Ewl9nw4M1vbA7FAnz7Em50fggjkdYQDyCqkcRSJH8Z4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)