UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3dxJkpYlB0Pg3uYjLS45idRpkuJ7g51sUTbEAY8THY8='
WHERE
key_id = '196eec1e08ed3cae65012513b42d77b1aa18a7234def941695781235d376237e'
AND (
token = '3dxJkpYlB0Pg3uYjLS45idRpkuJ7g51sUTbEAY8THY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)