UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pcsmVjPObAwTe9VbAiEnB5pgSaKz4iI0go1wrXL6API='
WHERE
key_id = 'bef8727efec51948645791107b97cf37a83596b111e5db87f7a57b12e3d8e52c'
AND (
token = 'pcsmVjPObAwTe9VbAiEnB5pgSaKz4iI0go1wrXL6API='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)