UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vJWdWZ+4hit9aviLTTRyLP/cvvfuZJIF0bl/4kiI1IA='
WHERE
key_id = 'ad448103b56d940aa60576f1efeb84ee05dd5dfff03a672dd7faf7f6fa2fa460'
AND (
token = 'vJWdWZ+4hit9aviLTTRyLP/cvvfuZJIF0bl/4kiI1IA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)