UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GF2b7XzP3aI7I0LvmT571Xi3KpbyY2TJqHyMe5Iy4Qw='
WHERE
key_id = '596e44fe7d2b16664b6b8f83c1f84f1031130901862c86a9f87ac967255efa2f'
AND (
token = 'GF2b7XzP3aI7I0LvmT571Xi3KpbyY2TJqHyMe5Iy4Qw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)