UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zV6IHBQuTpYI+6ubqiAM9p0cS2QH5XAkwrS//kMxvqE='
WHERE
key_id = 'cb63930e3c927c032f13545e7f23c852fcb206fae2e4891b484a2cd12a7500de'
AND (
token = 'zV6IHBQuTpYI+6ubqiAM9p0cS2QH5XAkwrS//kMxvqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)