UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VT+pbKn8s47us1lIoUuc2hMdV1KX4Jq4mle/4A9tjs4='
WHERE
key_id = '789c18ce6dd9b67c7dc6258b1ab4ffad054848379cbdbccd34c5baacab5edb9a'
AND (
token = 'VT+pbKn8s47us1lIoUuc2hMdV1KX4Jq4mle/4A9tjs4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)