UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KvZzFCaE+Vk+pMfb5k6z7iaOth9jtxFScNONBBsdVYw='
WHERE
key_id = '412c1c41caad458e1af38c2150d762a42972b024a3e3d85cfdba216d89354e0a'
AND (
token = 'KvZzFCaE+Vk+pMfb5k6z7iaOth9jtxFScNONBBsdVYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)