UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oJj2oDWIbuIQvxY3bAZk6HD/Iw7eO4CNGL9txnLfvGU='
WHERE
key_id = 'c24aae4484b8501f79617e87316f8ad911187dacb405a5dd95b05773a11a9607'
AND (
token = 'oJj2oDWIbuIQvxY3bAZk6HD/Iw7eO4CNGL9txnLfvGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)