UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XLgGOpH0vpYX1VzcBYbPRDlCp6zvKMQuIPFG92eOB1U='
WHERE
key_id = '7df807d5b00fc4ae0cc5ce50ff5c2c61b800b2c1e3ab82f629d0686a28b223ff'
AND (
token = 'XLgGOpH0vpYX1VzcBYbPRDlCp6zvKMQuIPFG92eOB1U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)