UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UoAPILkPQpX1+RgHrT0Elw0f9NZSBlKH6zZqWFCDK4g='
WHERE
key_id = 'c27444662e1f72f43cc43e6e3676f6871ab554e268cb8dd258ae546fccd1eaac'
AND (
token = 'UoAPILkPQpX1+RgHrT0Elw0f9NZSBlKH6zZqWFCDK4g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)