UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9pOx+x4zTq7SbmBSDf7bRdPbRyh1XWNYhJwrGZsH7YY='
WHERE
key_id = 'ea851d22aee236a33f1086ef9e455e88caac966be8bdd6f640ad9bacf330a53b'
AND (
token = '9pOx+x4zTq7SbmBSDf7bRdPbRyh1XWNYhJwrGZsH7YY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)