UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uHTcemcyzhuJKjhEVYp7ypc/Y2XghD5OukW56h9S9v8='
WHERE
key_id = 'dc9284c2b61548238f9f3e013fbccc76b6116a99200cd8814341c6f3d2bfbe74'
AND (
token = 'uHTcemcyzhuJKjhEVYp7ypc/Y2XghD5OukW56h9S9v8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)