UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PkCRg422KDvEU4zKrHZFbB3yFFizd4CGO+va7SgiIUI='
WHERE
key_id = 'edd81497a3f388be623e4662f551cbac4dc7de16ecdd3fc6f997127b690d8302'
AND (
token = 'PkCRg422KDvEU4zKrHZFbB3yFFizd4CGO+va7SgiIUI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)