UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6vYtC8g529feSueOJfPbOgXaADbn+tkQHYwypeT61Lk='
WHERE
key_id = 'b8f144b7acba74c0558ebd2d8234b64e096907ed9fef845aa5c2973c87c0443e'
AND (
token = '6vYtC8g529feSueOJfPbOgXaADbn+tkQHYwypeT61Lk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)