UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bh3TqC8utAfhyODKSBVSX9ZjBww2dZ5kaPqW4h3s2E4='
WHERE
key_id = '023a14fe52e3c6032763fd807198e61455b0fdf5a89ae669f78804361efc9627'
AND (
token = 'bh3TqC8utAfhyODKSBVSX9ZjBww2dZ5kaPqW4h3s2E4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)