UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jYXv+Neycf1WX51KtNVHFaJ9YvSo8HnvaD6v79+KeXs='
WHERE
key_id = 'c87b68fdb944ef5016163c6e14d50ec3e9bc0a20c01624c34a45cd54dbc723cb'
AND (
token = 'jYXv+Neycf1WX51KtNVHFaJ9YvSo8HnvaD6v79+KeXs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)