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