UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZQjk/7mU6WotShF6SAm8Lnl7KK4p4xemPS7lfLarEPo='
WHERE
key_id = '768a4492ed814f6bcc3f1abd386c793e57a60a1c90bdf2e0c660701a63619e86'
AND (
token = 'ZQjk/7mU6WotShF6SAm8Lnl7KK4p4xemPS7lfLarEPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)