UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZxE+vb6qX2cOykzE9Rv8/mLtOwdhfFBPOrLAqPx5Q2o='
WHERE
key_id = '78ca1540a32ac70927437e96a55007b9d278bdeea16c8717ac1f26e7e6487018'
AND (
token = 'ZxE+vb6qX2cOykzE9Rv8/mLtOwdhfFBPOrLAqPx5Q2o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)