UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4OlsqRNmDrnNyhUfaMGLZkt1SwjStW39k+N6Z8KyHCY='
WHERE
key_id = '3f8b9b9671549a88b05394a8031d770be74b80c881f3ec48d976a50f1c77b23a'
AND (
token = '4OlsqRNmDrnNyhUfaMGLZkt1SwjStW39k+N6Z8KyHCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)