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