UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XuaBPihN0onMf5CMyO40ARPHLE4/QFnb19yWe2k30QA='
WHERE
key_id = '6c16c408f36181cb74038f374332d92a62b18550f5ccadf90d9ef0fd185b6d2c'
AND (
token = 'XuaBPihN0onMf5CMyO40ARPHLE4/QFnb19yWe2k30QA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)