UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NQagFqAYsmNenCQr2g84IzVuB7gnFEc11Nkw5P8G8z8='
WHERE
key_id = '81b0f9f4889b068f6a07aaaa944f8a198e4a265ec73be299a524f6fbe3dd4548'
AND (
token = 'NQagFqAYsmNenCQr2g84IzVuB7gnFEc11Nkw5P8G8z8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)