UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WXd/A3xsS/uC1m1mIARpzm97XhPghjWGQbLs7WrolNg='
WHERE
key_id = 'd067faa97bac5c85ab4a36b01452be211077a5945f0e4fa3507e072a192a7796'
AND (
token = 'WXd/A3xsS/uC1m1mIARpzm97XhPghjWGQbLs7WrolNg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)