UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aYoEgU9xIBT2LqUB6zO10rGIEiKZaZ7gHAnwNFP6hSE='
WHERE
key_id = 'e8cb88ad67a26fa4259fc54c835d4fa3433dbb3247806cc02a4e243ad4fee146'
AND (
token = 'aYoEgU9xIBT2LqUB6zO10rGIEiKZaZ7gHAnwNFP6hSE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)