UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CiA6TLpmUa0gaFdwecr9AfYmSoL16Ool0m8nvGF0lu8='
WHERE
key_id = '7618473a2f3df253d5a0e466335a24f751655d74f8f8ad565fa16dd22f9de0e8'
AND (
token = 'CiA6TLpmUa0gaFdwecr9AfYmSoL16Ool0m8nvGF0lu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)