UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V9SB5Hvar4tBkQfcODKd3xVopw/19K5wCnZrPjCi4Uw='
WHERE
key_id = '28856480c512552d2d93804f852a390eb965c5934165fdd4b22618a3f52bdf34'
AND (
token = 'V9SB5Hvar4tBkQfcODKd3xVopw/19K5wCnZrPjCi4Uw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)