UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6AWJSng5P5q8J3f1sPFiEBuiJM1iowlTl6M3WbuX8vQ='
WHERE
key_id = 'a196baa1e436b386a63388d47ffb5057dce1ac41be859357c0f43aac15873271'
AND (
token = '6AWJSng5P5q8J3f1sPFiEBuiJM1iowlTl6M3WbuX8vQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)