UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bK2zNxc78vQ+Equ93HpM52MBvDrIUNzWNo3AXpxG2F8='
WHERE
key_id = '0667098152aefa95b66678c40a3651f96fb22c4120b6c25886824c1c89139999'
AND (
token = 'bK2zNxc78vQ+Equ93HpM52MBvDrIUNzWNo3AXpxG2F8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)