UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x9Jn2QJkSwv+iKZxSg+UW/oY+wTMpdovoPH5IbLe4Zc='
WHERE
key_id = 'd1ca004e43ebdcdb9c9700cdfc5cc3f1238ae489571b78367c4ea36b8ab9383d'
AND (
token = 'x9Jn2QJkSwv+iKZxSg+UW/oY+wTMpdovoPH5IbLe4Zc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)