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