UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zgXF/U3qYYSv+8W+aGE8lwnsyH0QstCum/fi+pAyF74='
WHERE
key_id = '1da963370b2e4a4cac0b7acd120f510967888292b6e5334019116540796f8e72'
AND (
token = 'zgXF/U3qYYSv+8W+aGE8lwnsyH0QstCum/fi+pAyF74='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)