UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c6TeLecU+SpEnvDujCqDQQYE/9Is4ZFV0+PMgQx2dtk='
WHERE
key_id = 'd28a71f5546e520275e3ef0f7e216e7955b5c07b5ad610913564c57f27486620'
AND (
token = 'c6TeLecU+SpEnvDujCqDQQYE/9Is4ZFV0+PMgQx2dtk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)