UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oiGf0PWYMQhosJXqxilg8xwHUA+CLCrKeLUbSekOg+M='
WHERE
key_id = '4821b24fe7f0f2c60073c50c829affad756369778a84b14f4273b82b85a96fc0'
AND (
token = 'oiGf0PWYMQhosJXqxilg8xwHUA+CLCrKeLUbSekOg+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)