UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KoNc88lHukIovJEZBC4VcbyWgOLiumZlsOM7+8kbgGs='
WHERE
key_id = '3dfdf3191c281d21a061469a0d61be870b5e216a3bef11cdc9f236b3a15a0ee7'
AND (
token = 'KoNc88lHukIovJEZBC4VcbyWgOLiumZlsOM7+8kbgGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)