UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GnzRiOuUh7uifFVRRYYb3672LnIpP+C58AYeeMki7HI='
WHERE
key_id = '179bee3ba86a4f324eff1e6691988c073a1c71d57f357219dca185cc3f9f6130'
AND (
token = 'GnzRiOuUh7uifFVRRYYb3672LnIpP+C58AYeeMki7HI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)